﻿ IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_DeleteLocation')
	BEGIN
		DROP  Procedure  esf_sso.P_DeleteLocation
	END

GO

CREATE Procedure esf_sso.P_DeleteLocation
	@pID					BIGINT
AS

	DELETE FROM [esf_sso].[Location]
	WHERE ID = @pID 
           
GO  